alter table jms_dm.dm_tab_interceptor_waybill_kafka_hi
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_tab_interceptor_waybill_kafka_hi;
create external table jms_dm.dm_tab_interceptor_waybill_kafka_hi
(
    waybill_no string comment '运单号',
    input_time string comment '订单录入时间年月日时分秒',
    date_time  string comment '订单录入日期年月日',
    status     int comment '--0失效 1生效',
    sys_time   string comment '系统时间'
) COMMENT '疫情订单拦中间表'
    PARTITIONED BY ( dt STRING COMMENT '小时')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_tab_interceptor_waybill_kafka_hi'
;
